﻿namespace QMVnSoft.DAL
{
    using System;
    using System.Data;
    using System.Data.SqlClient;

    public class ReportDataAccess
    {
        public DataTable DMVT02_Get(object ps_ParentCode)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Nh_Vt", ps_ParentCode) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "DmVt_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable GetReportList(object ps_UserName, object ps_Groups)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_UserName", ps_UserName), new SqlParameter("p_RepoGrp", ps_Groups) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "Reports_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCD04_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_154, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Tk_621, object ps_Tk_622, object ps_Tk_623, object ps_Tk_627, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_154", ps_Tk_154), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Tk_621", ps_Tk_621), new SqlParameter("p_Tk_622", ps_Tk_622), new SqlParameter("p_Tk_623", ps_Tk_623), new SqlParameter("p_Tk_627", ps_Tk_627), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCD04_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCD20_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Result", SqlDbType.BigInt) };
            values[5].Direction = ParameterDirection.Output;
            values[5].SqlDbType = SqlDbType.Int;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "MasterProductCosting";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Dt_Du, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Ct", ps_Ma_Ct), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Tk_Du", ps_Tk_Du), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Dt_Du", ps_Ma_Dt_Du), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT01SC_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Dt_Du, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Ct", ps_Ma_Ct), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Tk_Du", ps_Tk_Du), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Dt_Du", ps_Ma_Dt_Du), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT01SC_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT01T_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object pi_Bac_Tk, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Bac_Tk", pi_Bac_Tk), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT01T_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Yt, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Yt", ps_Ma_Yt), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT02_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT02A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT03_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT03_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT04_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT04_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT04A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT04A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT04B_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT04B_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT06_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_So_Ct1, object ps_So_Ct2, object ps_Tk, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Ct", ps_Ma_Ct), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT06_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT071_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_133, object ps_HD_Huy, ref object pi_TTien, ref object pi_TTien3, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_133", ps_Tk_133), new SqlParameter("p_HD_Huy", ps_HD_Huy), new SqlParameter("p_TTien", null), new SqlParameter("p_TTien3", null), new SqlParameter("p_English", pi_English) };
            values[5].Direction = ParameterDirection.Output;
            values[5].SqlDbType = SqlDbType.Decimal;
            values[6].Direction = ParameterDirection.Output;
            values[6].SqlDbType = SqlDbType.Decimal;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT071_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                pi_TTien = values[5].Value;
                pi_TTien3 = values[6].Value;
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }
        public DataTable KTH11_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_No_Co, object ps_Tk, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_VND_NT, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_VND_NT", pi_VND_NT), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH11_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }
        public DataTable VCD06_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_No_Co, object ps_Tk, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCD06_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }
        public DataTable KCD02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Ngay_Ky, object ps_No_Co, object ps_Tk, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object pi_VND_NT, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ngay_Ky", pi_Ngay_Ky), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_VND_NT", pi_VND_NT), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCD02_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }
        public DataTable KCT072_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_3331, object ps_HD_Huy, ref object pi_TTien, ref object pi_TTien3, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_3331", ps_Tk_3331), new SqlParameter("p_HD_Huy", ps_HD_Huy), new SqlParameter("p_TTien", null), new SqlParameter("p_TTien3", null), new SqlParameter("p_English", pi_English) };
            values[5].Direction = ParameterDirection.Output;
            values[5].SqlDbType = SqlDbType.Decimal;
            values[6].Direction = ParameterDirection.Output;
            values[6].SqlDbType = SqlDbType.Decimal;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT072_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                pi_TTien = values[5].Value;
                pi_TTien3 = values[6].Value;
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT073_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_133, object ps_HD_Huy, ref object pi_TTien, ref object pi_TTien3, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_133", ps_Tk_133), new SqlParameter("p_HD_Huy", ps_HD_Huy), new SqlParameter("p_TTien", null), new SqlParameter("p_TTien3", null), new SqlParameter("p_English", pi_English) };
            values[5].Direction = ParameterDirection.Output;
            values[5].SqlDbType = SqlDbType.Decimal;
            values[6].Direction = ParameterDirection.Output;
            values[6].SqlDbType = SqlDbType.Decimal;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT073_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                pi_TTien = values[5].Value;
                pi_TTien3 = values[6].Value;
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT074_Get(object pd_Ngay_Ct1, object pd_Ngay_Ct2)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT074_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT10_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_So_Ct1, object ps_So_Ct2, object pi_TTien_Nt1, object pi_TTien_Nt2, object ps_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Hd, object ps_Ma_Bp, object ps_Ma_Km, object ps_Ma_Sp, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ong_Ba, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Ct", ps_Ma_Ct), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_TTien_Nt1", pi_TTien_Nt1), new SqlParameter("p_TTien_Nt2", pi_TTien_Nt2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Tk_Du", ps_Tk_Du), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), 
                new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT10_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT11_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_621, object ps_Tk_622, object ps_Tk_623, object ps_Tk_627, object ps_Tk_635, object ps_Tk_641, object ps_Tk_642, object ps_Tk_List, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_621", ps_Tk_621), new SqlParameter("p_Tk_622", ps_Tk_622), new SqlParameter("p_Tk_623", ps_Tk_623), new SqlParameter("p_Tk_627", ps_Tk_627), new SqlParameter("p_Tk_635", ps_Tk_635), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_Tk_List", ps_Tk_List), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT11_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KCT12_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_No_Co, ref object ps_Tk_Du1, ref object ps_Tk_Du2, ref object ps_Tk_Du3, ref object ps_Tk_Du4, ref object ps_Tk_Du5, ref object ps_Tk_Du6, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[12];
            values[0] = new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries);
            values[1] = new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1);
            values[2] = new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2);
            values[3] = new SqlParameter("p_Tk", ps_Tk);
            values[4] = new SqlParameter("p_No_Co", ps_No_Co);
            values[5] = new SqlParameter("p_Tk_Du1", ps_Tk_Du1);
            values[5].Direction = ParameterDirection.InputOutput;
            values[5].SqlDbType = SqlDbType.NVarChar;
            values[5].Size = 0x20;
            values[6] = new SqlParameter("p_Tk_Du2", ps_Tk_Du2);
            values[6].Direction = ParameterDirection.InputOutput;
            values[6].SqlDbType = SqlDbType.NVarChar;
            values[6].Size = 0x20;
            values[7] = new SqlParameter("p_Tk_Du3", ps_Tk_Du3);
            values[7].Direction = ParameterDirection.InputOutput;
            values[7].SqlDbType = SqlDbType.NVarChar;
            values[7].Size = 0x20;
            values[8] = new SqlParameter("p_Tk_Du4", ps_Tk_Du4);
            values[8].Direction = ParameterDirection.InputOutput;
            values[8].SqlDbType = SqlDbType.NVarChar;
            values[8].Size = 0x20;
            values[9] = new SqlParameter("p_Tk_Du5", ps_Tk_Du5);
            values[9].Direction = ParameterDirection.InputOutput;
            values[9].SqlDbType = SqlDbType.NVarChar;
            values[9].Size = 0x20;
            values[10] = new SqlParameter("p_Tk_Du6", ps_Tk_Du6);
            values[10].Direction = ParameterDirection.InputOutput;
            values[10].SqlDbType = SqlDbType.NVarChar;
            values[10].Size = 0x20;
            values[11] = new SqlParameter("p_English", pi_English);
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KCT12_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                ps_Tk_Du1 = values[5].Value;
                ps_Tk_Du2 = values[6].Value;
                ps_Tk_Du3 = values[7].Value;
                ps_Tk_Du4 = values[8].Value;
                ps_Tk_Du5 = values[9].Value;
                ps_Tk_Du6 = values[10].Value;
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KQT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Bd_Ht, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ngay_Bd_Ht", pd_Ngay_Bd_Ht), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KQT01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KQT02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Ct0, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ngay_Ct0", pd_Ngay_Ct0), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KQT02_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KQT031_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Ct0, object ps_Tk_List, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ngay_Ct0", pd_Ngay_Ct0), new SqlParameter("p_Tk_List", ps_Tk_List), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KQT031_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KQT032_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pd_Ngay_Ct0, object ps_Tk_List0, object ps_Tk_List1, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ngay_Ct0", pd_Ngay_Ct0), new SqlParameter("p_Tk_List0", ps_Tk_List0), new SqlParameter("p_Tk_List1", ps_Tk_List1), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KQT032_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KQT05_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Tien_DN, ref object ps_Mua_Ban_Ck, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tien_DN", pi_Tien_DN), new SqlParameter("p_Mua_Ban_Ck", null), new SqlParameter("p_English", pi_English) };
            values[4].Direction = ParameterDirection.Output;
            values[4].SqlDbType = SqlDbType.NVarChar;
            values[4].Size = 1;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KQT05_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                ps_Mua_Ban_Ck = values[4].Value;
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Ct, object ps_Tk, object pi_Bac_Tk, object ps_Tk_Du, object ps_No_Co, object ps_Ma_Dt, object ps_Ma_Dt_Du, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Ct", ps_Ma_Ct), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Bac_Tk", pi_Bac_Tk), new SqlParameter("p_Tk_Du", ps_Tk_Du), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Dt_Du", ps_Ma_Dt_Du), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Dt, object ps_Ma_Nh_Dt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH02_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH03A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Tk_641, object ps_Tk_642, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH03A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH03B_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Kieu_BC, object ps_Kieu_Gia, object ps_Lay_DD, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Kieu_BC", ps_Kieu_BC), new SqlParameter("p_Kieu_Gia", ps_Kieu_Gia), new SqlParameter("p_Lay_DD", ps_Lay_DD), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH03B_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH03C_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH03C_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH03E_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Kieu_BC, object ps_Kieu_Gia, object ps_Lay_DD, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Kieu_BC", ps_Kieu_BC), new SqlParameter("p_Kieu_Gia", ps_Kieu_Gia), new SqlParameter("p_Lay_DD", ps_Lay_DD), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH03E_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH03H_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Kieu_BC, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Kieu_BC", ps_Kieu_BC), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH03H_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH04_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_List, object ps_No_Co, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_List", ps_Tk_List), new SqlParameter("p_No_Co", ps_No_Co), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH04_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH05_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Ma_Yt, object ps_Ma_Dm_Sp, object ps_UserName, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Ma_Yt", ps_Ma_Yt), new SqlParameter("p_Ma_Dm_Sp", ps_Ma_Dm_Sp), new SqlParameter("p_UserName", ps_UserName), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH05_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH05A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Sp_Me, object ps_Ma_Sp, object ps_Ma_Yt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Ma_Yt", ps_Ma_Yt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH05A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH06_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Yt, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Yt", ps_Ma_Yt), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH06_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH06A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Ma_Sp_Me, object ps_Ma_Sp, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Ma_Sp_Me", ps_Ma_Sp_Me), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH06A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH08_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk, object ps_Tk_List, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_Tk_List", ps_Tk_List), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH08_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH09_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Revenue, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Revenue", pi_Revenue), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH09_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH10_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_CP_List, object ps_Tk_GT_List, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_CP_List", ps_Tk_CP_List), new SqlParameter("p_Tk_GT_List", ps_Tk_GT_List), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH10_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTH10A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Tk_621, object ps_Tk_622, object ps_Tk_623, object ps_Tk_627, object ps_Tk_635, object ps_Tk_641, object ps_Tk_642, object ps_Tk_List, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Tk_621", ps_Tk_621), new SqlParameter("p_Tk_622", ps_Tk_622), new SqlParameter("p_Tk_623", ps_Tk_623), new SqlParameter("p_Tk_627", ps_Tk_627), new SqlParameter("p_Tk_635", ps_Tk_635), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_Tk_List", ps_Tk_List), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTH10A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable KTS01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Bp, object ps_Ma_Nh_Ts, object ps_Ma_Ts, object ps_Loai_Ts, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Nh_Ts", ps_Ma_Nh_Ts), new SqlParameter("p_Ma_Ts", ps_Ma_Ts), new SqlParameter("p_Loai_Ts", ps_Loai_Ts), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_KTS01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public int SaveReportRow(bool pb_NewChecked, ref object pi_Stt, object pi_Stt0, object ps_Bar, object ps_Bar_E, object ps_Title, object ps_Title_E, object ps_FormFile, object ps_RepoFile, object ps_RepoGrp, object ps_Series, object pb_OnTop)
        {
            int num;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Moi_Sua", pb_NewChecked), new SqlParameter("p_Stt", pi_Stt), new SqlParameter("p_Stt0", pi_Stt0), new SqlParameter("p_Bar", ps_Bar), new SqlParameter("p_Bar_E", ps_Bar_E), new SqlParameter("p_Title", ps_Title), new SqlParameter("p_Title_E", ps_Title_E), new SqlParameter("p_FormFile", ps_FormFile), new SqlParameter("p_RepoFile", ps_RepoFile), new SqlParameter("p_RepoGrp", ps_RepoGrp), new SqlParameter("p_Series", ps_Series), new SqlParameter("p_OnTop", pb_OnTop), new SqlParameter("p_Result", SqlDbType.BigInt) };
            values[1].Direction = ParameterDirection.InputOutput;
            values[1].SqlDbType = SqlDbType.BigInt;
            values[12].Direction = ParameterDirection.Output;
            values[12].SqlDbType = SqlDbType.Int;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "Reports_Save";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                command.ExecuteNonQuery();
                AppDataAccess.CloseConnection(eZConnection);
                pi_Stt = values[1].Value;
                num = (int) values[12].Value;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return num;
        }

        public DataTable VCD01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCD01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCD02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCD02_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCD02L_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCD02L_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCD02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCD02A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT00HD_Get(object ps_Subsidiaries, object ps_Nh_Ct, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Nh_Ct", ps_Nh_Ct), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), 
                new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_No", ps_Tk_No), new SqlParameter("p_Tk_Co", ps_Tk_Co), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT00HD_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT00N_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), 
                new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_No", ps_Tk_No), new SqlParameter("p_Tk_Co", ps_Tk_Co), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT00N_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT00X_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), 
                new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_No", ps_Tk_No), new SqlParameter("p_Tk_Co", ps_Tk_Co), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT00X_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT01HD_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), 
                new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_No", ps_Tk_No), new SqlParameter("p_Tk_Co", ps_Tk_Co), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT01HD_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT01N_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), 
                new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_No", ps_Tk_No), new SqlParameter("p_Tk_Co", ps_Tk_Co), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT01N_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VCT01X_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Dien_Giai, object ps_Desc_EN, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_No, object ps_Tk_Co, object ps_Ong_Ba, object ps_Tk_621, object ps_Tk_627, object ps_Tk_632, object ps_Tk_641, object ps_Tk_642, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Dien_Giai", ps_Dien_Giai), new SqlParameter("p_Desc_EN", ps_Desc_EN), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), 
                new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_No", ps_Tk_No), new SqlParameter("p_Tk_Co", ps_Tk_Co), new SqlParameter("p_Ong_Ba", ps_Ong_Ba), new SqlParameter("p_Tk_621", ps_Tk_621), new SqlParameter("p_Tk_627", ps_Tk_627), new SqlParameter("p_Tk_632", ps_Tk_632), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VCT01X_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VTH01HDA_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), 
                new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VTH01HDA_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VTH01HDB_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), new SqlParameter("p_Ma_Nx", ps_Ma_Nx), 
                new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VTH01HDB_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VTH01N_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), 
                new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VTH01N_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VTH01X_Get(object ps_Subsidiaries, object ps_Ma_Ct_List, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_So_Ct1, object ps_So_Ct2, object pi_Tien1, object pi_Tien2, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Kho, object ps_Ma_Vt, object ps_Ma_Bp, object ps_Ma_Sp, object ps_Ma_Hd, object ps_Ma_Km, object ps_Ma_Nx, object ps_Tk_621, object ps_Tk_627, object ps_Tk_632, object ps_Tk_641, object ps_Tk_642, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { 
                new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ma_Ct_List", ps_Ma_Ct_List), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_So_Ct1", ps_So_Ct1), new SqlParameter("p_So_Ct2", ps_So_Ct2), new SqlParameter("p_Tien1", pi_Tien1), new SqlParameter("p_Tien2", pi_Tien2), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Ma_Bp", ps_Ma_Bp), new SqlParameter("p_Ma_Sp", ps_Ma_Sp), new SqlParameter("p_Ma_Hd", ps_Ma_Hd), new SqlParameter("p_Ma_Km", ps_Ma_Km), 
                new SqlParameter("p_Ma_Nx", ps_Ma_Nx), new SqlParameter("p_Tk_621", ps_Tk_621), new SqlParameter("p_Tk_627", ps_Tk_627), new SqlParameter("p_Tk_632", ps_Tk_632), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_English", pi_English)
             };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VTH01X_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VTH02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Tk_641, object ps_Tk_642, object ps_Loai_PB, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_Loai_PB", ps_Loai_PB), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VTH02A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable VTH02B_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Nh_Dt, object ps_Ma_Dt, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object ps_Tk_641, object ps_Tk_642, object ps_Loai_PB, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Nh_Dt", ps_Ma_Nh_Dt), new SqlParameter("p_Ma_Dt", ps_Ma_Dt), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_Tk_641", ps_Tk_641), new SqlParameter("p_Tk_642", ps_Tk_642), new SqlParameter("p_Loai_PB", ps_Loai_PB), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_VTH02B_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable WCD01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_WCD01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable WCD02_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_WCD02_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable WCD02A_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object ps_Ma_Kho, object ps_Ma_Nh_Vt, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Nh_Vt", ps_Ma_Nh_Vt), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_WCD02A_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

        public DataTable WCT01_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object ps_Ma_Kho, object ps_Ma_Vt, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs_List", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Ma_Kho", ps_Ma_Kho), new SqlParameter("p_Ma_Vt", ps_Ma_Vt), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "RPT_WCT01_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }
        public DataTable KTSS_Get(object ps_Subsidiaries, object pd_Ngay_Ct1, object pd_Ngay_Ct2, object pi_Check_Type, object ps_Tk, object pi_English)
        {
            DataTable table2;
            SqlParameter[] values = new SqlParameter[] { new SqlParameter("p_Ma_Dvcs", ps_Subsidiaries), new SqlParameter("p_Ngay_Ct1", pd_Ngay_Ct1), new SqlParameter("p_Ngay_Ct2", pd_Ngay_Ct2), new SqlParameter("p_Check_Type", pi_Check_Type), new SqlParameter("p_Tk", ps_Tk), new SqlParameter("p_English", pi_English) };
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "DataLogicalCheck";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                command.Parameters.AddRange(values);
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }
        public DataTable Check_Error_Get()
        {
            DataTable table2;
            SqlConnection eZConnection = AppDataAccess.AppConnection;
            DataTable dataTable = new DataTable();
            SqlDataAdapter adapter = new SqlDataAdapter();
            SqlCommand command = new SqlCommand();
            try
            {
                command.CommandText = "Check_Get";
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = eZConnection;
                adapter.SelectCommand = command;
                adapter.Fill(dataTable);
                AppDataAccess.CloseConnection(eZConnection);
                table2 = dataTable;
            }
            catch (Exception exception)
            {
                throw new NotSupportedException("Invalid expression", exception);
            }
            return table2;
        }

    }
}

